﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Store Manager/SM_panel.master" AutoEventWireup="true" CodeFile="SM_SAN_Approval.aspx.cs" Inherits="Store_Manager_SM_SAN_Approval" %>

<%@ Register Assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2.Export, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style2
        {
            width: 100%;
        }


    .style3
    {
        width: 206px;
    }
    .style4
    {
        width: 189px;
    }

    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <table class="style2">
        <tr>
            <td class="style3">
                &nbsp;</td>
            <td>
                Select SAN No:</td>
            <td>
                <strong>
               
                
                <dx:ASPxComboBox ID="DropDownList1" runat="server" ClientIDMode="AutoID"  
                     DropDownStyle="DropDown" IncrementalFilteringMode="StartsWith"
                 DataSourceID="SqlDataSource2" 
                           
                    TextField="SA_id" TextFormatString="{0}"  ValueType="System.String"
                            ValueField="SA_id" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                       
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    Width="200px" AutoPostBack="True" EnableIncrementalFiltering="True" 
                        >
                        <LoadingPanelImage Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                        </LoadingPanelImage>
                        <ButtonStyle Width="11px">
                        </ButtonStyle>
                        <ValidationSettings ErrorText="Error has occurred">
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                        </ValidationSettings>
                    </dx:ASPxComboBox>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                    
                    SelectCommand="SELECT [SA_ID] FROM [tblStock_Adjustment] WHERE ([managerapproval] IS NULL)">
                </asp:SqlDataSource>
                </strong>
            </td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td colspan="4">
                <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" 
                    ClientIDMode="AutoID" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                    CssPostfix="BlackGlass" DataSourceID="SqlDataSource1" KeyFieldName="SA_ID;Sto_ID;Pro_ID;Code;Qty" 
                    Width="100%">
                    <Columns>
                        <dx:GridViewCommandColumn ShowSelectCheckbox="True" VisibleIndex="0">
                            <ClearFilterButton Visible="True">
                            </ClearFilterButton>
                        </dx:GridViewCommandColumn>
                        <dx:GridViewDataTextColumn FieldName="SA_ID" ReadOnly="True" Visible="False" 
                            VisibleIndex="0">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Stock ID" FieldName="Sto_ID" 
                            VisibleIndex="1">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Item ID" FieldName="Pro_ID" ReadOnly="True" 
                            VisibleIndex="2">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Item Code" FieldName="Code" ReadOnly="True" 
                            VisibleIndex="3">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Item" FieldName="Pro_Name" VisibleIndex="4">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Brand" FieldName="Brand_Name" 
                            VisibleIndex="5">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Marked Price" FieldName="Ret_Price" 
                            VisibleIndex="6">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Cost" FieldName="Pur_Price" 
                            VisibleIndex="7">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="PV" FieldName="Point_Value" 
                            VisibleIndex="8">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="BV" FieldName="Business_Value" 
                            VisibleIndex="9">
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn Caption="Quantity" FieldName="Qty" VisibleIndex="10">
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <Settings ShowFilterRow="True" />
                    <Images SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                        <LoadingPanelOnStatusBar Url="~/App_Themes/BlackGlass/GridView/gvLoadingOnStatusBar.gif">
                        </LoadingPanelOnStatusBar>
                        <LoadingPanel Url="~/App_Themes/BlackGlass/GridView/Loading.gif">
                        </LoadingPanel>
                    </Images>
                    <ImagesFilterControl>
                        <LoadingPanel Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                        </LoadingPanel>
                    </ImagesFilterControl>
                    <Styles CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                        CssPostfix="BlackGlass">
                        <Header ImageSpacing="5px" SortingImageSpacing="5px">
                        </Header>
                    </Styles>
                    <StylesEditors>
                        <CalendarHeader Spacing="1px">
                        </CalendarHeader>
                        <ProgressBar Height="25px">
                        </ProgressBar>
                    </StylesEditors>
                </dx:ASPxGridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                    SelectCommand="SELECT tblStock_Adjustment_Details.SA_ID, tblStock_Adjustment_Details.Sto_ID, tblStock_Adjustment_Details.Qty, tblStock_Adjustment_Details.User_Create, tblStock_Adjustment_Details.Date_Create, tblStock_Adjustment_Details.Last_Modify, tblStock_Adjustment_Details.Key_Timestamp, tblStock_Adjustment_Details.Pro_ID, tblStock_Adjustment_Details.Code, Tbl_Product.Pro_Name, Tbl_Product.Brand_Name, Tbl_Product.Ret_Price, Tbl_Product.Pur_Price, Tbl_Product.Point_Value, Tbl_Product.Business_Value FROM tblStock_Adjustment_Details INNER JOIN Tbl_Product ON tblStock_Adjustment_Details.Code = Tbl_Product.Code AND tblStock_Adjustment_Details.Pro_ID = Tbl_Product.Pro_ID WHERE (tblStock_Adjustment_Details.SA_ID = @SA_ID)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="DropDownList1" Name="SA_ID" 
                            PropertyName="Value" Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <table class="style2">
                    <tr>
                        <td class="style4">
                            <dx:ASPxLabel ID="ASPxLabel4" runat="server" ForeColor="Red" Text="ASPxLabel">
                            </dx:ASPxLabel>
                        </td>
                        <td>
                            <dx:ASPxButton ID="ASPxButton1" runat="server" ClientIDMode="AutoID" 
                                CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                                onclick="ASPxButton1_Click" 
                                SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Text="Approve">
                            </dx:ASPxButton>
                        </td>
                        <td>
                            &nbsp;</td>
                        <td>
                            &nbsp;</td>
                    </tr>
                    <tr>
                        <td class="style4">
                            &nbsp;</td>
                        <td>
                            &nbsp;</td>
                        <td>
                            &nbsp;</td>
                        <td>
                            &nbsp;</td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</asp:Content>

